﻿-- ===============================================================================================
-- Basic View for Deptos of Countries
-- ===============================================================================================

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[esf_sso].[VDepto]'))
	DROP VIEW [esf_sso].[VDepto]
GO

-- SELECT * FROM [esf_sso].[VDepto]

CREATE VIEW [esf_sso].[VDepto] AS
	SELECT * FROM esf_sso.VBasicReference WHERE BasicReferenceTypeID = 9
	
GO  